Important When you break a link to a source, all formulas that that use the source are converted to their current value. For example, the link =SUM([Budget.xls]Annual!C10:C25) would be converted to =45. Because this action cannot be undone, you may want to save a version of the file before you start.
To select multiple linked objects, hold down CTRL and click each linked object.
To select all links, press CTRL+A.
Change it in the Refers to box.
Click Delete.
Control the startup prompt for updating links
Don't prompt for all workbooks I open, and update the links automatically
This option is for the current user only, and affects every workbook opened. Other users of the workbook are not affected.
On the Tools menu, click Options, and then click the Edit tab.
Clear the Ask to update automatic links check box. If the box is cleared, the links are automatically updated, and no alert is displayed.
Prompt in the same way for every user of the workbook
Warning This option affects all users of the workbook. If you choose to not update links, and not to prompt, users of the workbook will not know the data is out of date.
On Edit menu, click Links.
Click Startup Prompt.
Select the option you want.
Note You will still be notified if there are any broken links.
Replace a single formula with its calculated value
Caution When you replace a formula with its value, Microsoft Excel permanently removes the formula. If you accidentally replace a formula with a value and want to restore the formula, click Undo immediately after you enter or paste the value.
If the formula is an array formula, select the range that contains the array formula.